/*
This file is part of Ext JS 4

Copyright (c) 2011 Sencha Inc

Contact:  http://www.sencha.com/contact

GNU General Public License Usage
This file may be used under the terms of the GNU General Public License version 3.0 as published by the Free Software Foundation and appearing in the file LICENSE included in the packaging of this file.  Please review the following information to ensure the GNU General Public License version 3.0 requirements will be met: http://www.gnu.org/copyleft/gpl.html.

If you are unsure which license is appropriate for your use, please contact the sales department at http://www.sencha.com/contact.

*/
/*!
 * Ext JS Library 4.0
 * Copyright(c) 2006-2011 Sencha Inc.
 * licensing@sencha.com
 * http://www.sencha.com/license
 */
Ext.define('Nacionalidad',{
    extend: 'Ext.data.Model',
    //idProperty:'',
    fields: [
        {name:'IdNacionalidad', type:'int'},
        {name:'Nacionalidad',   type:'string'},
        {name:'CodSunat',   type:'string'}
    ]
});

Ext.define('Tipoafiliacion',{
    extend: 'Ext.data.Model',
    //idProperty:'',
    fields: [
        {name:'IdTipoAfiliacion', type:'int'},
        {name:'NomTipoAfiliacion',   type:'string'}
    ]
});

Ext.define('SistemaPension',{
    extend: 'Ext.data.Model',
   // idProperty:'Id',
    fields: [
        {name:'IdSistemaPensiones', type:'int'},
        {name:'Nombre',   type:'string'},
        {name:'Descripcion',   type:'string'}
    ]
});

Ext.define('Estado',{
    extend: 'Ext.data.Model',
    //idProperty:'',
    fields: [
        {name:'IdEstado', type:'boolean'},
        {name:'Estado',   type:'string'}
    ]
});

Ext.define('SistemaPensionE',{
    extend: 'Ext.data.Model',
    //idProperty:'Id',
    fields: [
        {name:'Id', type:'int'},
        {name:'IdPersonal',   type:'string'},
        {name:'IdSistemaPensiones',   type:'int'},
        {name:'NombreSistemapension',   type:'string'},
        {name:'NombreCorto',   type:'string'},
        {name:'FechaAfiliacion',   type:'string'},
        {name:'Cuspp',   type:'string'},
        {name:'IdEstado',   type:'boolean'},
        {name:'IdTipoAfiliacion',   type:'int'},
        {name:'NombreAfiliacion',   type:'string'},

    ]
});
Ext.define('CategoriaRRHH',{
    extend: 'Ext.data.Model',
    //idProperty:'',
    fields: [
        {name:'IdCategoria', type:'int'},
        {name:'NomCategoriaRRHH',   type:'string'}
    ]
});

Ext.define('TipoTrabajador',{
    extend: 'Ext.data.Model',
    //idProperty:'',
    fields: [
        {name:'IdTipoTrabajador', type:'int'},
        {name:'IdCategoria',   type:'string'},
        {name:'NomTipoTrabajador',   type:'string'},
        {name:'CodSunatTipoTrab',   type:'string'},
        {name:'Disponible',   type:'bool'}
    ]
});

Ext.define('TipoContrato',{
    extend: 'Ext.data.Model',
    //idProperty:'',
    fields: [
        {name:'IdTipoContrato', type:'int'},
        {name:'IdCategoria',   type:'string'},
        {name:'NomTipoContrato',   type:'string'},
        {name:'CodSunatTipoContrato',   type:'string'}
    ]
});

Ext.define('GrupoOcupacional',{
    extend: 'Ext.data.Model',
    //idProperty:'',
    fields: [
        {name:'IdGrupoOcupacional', type:'int'},
        {name:'NomGrupoOcupacional',   type:'string'},
        {name:'CodSunatGrupoOcupacional',   type:'string'}
    ]
});

Ext.define('Area',{
    extend: 'Ext.data.Model',
    //idProperty:'',
    fields: [
        {name:'IdArea', type:'int'},
        {name:'NomArea',   type:'string'}
        //,{name:'CodSunatGrupoOcupacional',   type:'string'}
    ]
});

Ext.define('Posicion',{
    extend: 'Ext.data.Model',
    //idProperty:'',
    fields: [
        {name:'IdPosicion', type:'int'},
        {name:'IdCargo', type:'int'},
        {name:'NomCargo',   type:'string'},
        {name:'IdPosicionJefeInmediato', type:'int'},
        {name:'NomCargoJefeInmediato',   type:'string'},
        {name:'Confianza', type:'bool'},
        {name:'JefeArea', type:'bool'}
        //,{name:'CodSunatGrupoOcupacional',   type:'string'}
    ]
});

Ext.define('Cargo',{
    extend: 'Ext.data.Model',
    //idProperty:'',
    fields: [
        {name:'IdCargo', type:'int'},
        { name: 'NomCargo', type: 'string' },
        {name:'DescCargo',   type:'string'}
        //,{name:'CodSunatGrupoOcupacional',   type:'string'}
    ]
});

Ext.define('JefeInmediato',{
    extend: 'Ext.data.Model',
    //idProperty:'',
    fields: [
        {name:'IdPosicionJefeInmediato', type:'int'},
        {name:'NomCargoJefeInmediato',   type:'string'}
        //,{name:'CodSunatGrupoOcupacional',   type:'string'}
    ]
});

Ext.define('Horario',{
    extend: 'Ext.data.Model',
    idProperty:'IdHorario',
    fields: [
        {name:'IdHorario', type:'int'},
        {name:'NomHorario',   type:'string'}
        ,{name:'CicloHorario',   type:'string'}
    ]
});

Ext.define('TipoPagoPlanilla',{
    extend: 'Ext.data.Model',
    idProperty:'IdTipoPagoPlanilla',
    fields: [
        {name:'IdTipoPagoPlanilla', type:'int'},
        {name:'NomTipoPagoPlanilla',   type:'string'}
    ]
});

Ext.define('PeriodicidadIngreso',{
    extend: 'Ext.data.Model',
    idProperty:'IdPeriodicidadIngreso',
    fields: [
        {name:'IdPeriodicidadIngreso', type:'int'},
        {name:'NomPeriodicidadIngreso',   type:'string'}
    ]
});

Ext.define('NivelEducativo',{
    extend: 'Ext.data.Model',
    //idProperty:'',
    fields: [
        {name:'IdNivelEducativo', type:'int'},
        {name:'NomNivelEducativo',   type:'string'},
        {name:'CodSunatNivelEducativo',   type:'string'}
    ]
});

Ext.define('TipoDocumentoIdentidad',{
    extend: 'Ext.data.Model',
    //idProperty:'',
    fields: [
        {name:'IdTipoDI', type:'int'},
        {name:'Descripcion',   type:'string'},
        {name:'CodSunat',   type:'string'}
    ]
});

Ext.define('PlanillaBoleta',{
    extend: 'Ext.data.Model',
    //idProperty:'',
    fields: [
        {name:'Nro', type:'int'},
        {name:'IdPersonal', type:'int'},
        {name:'TipoTrabajador',   type:'string'},
        {name:'Fotocheck',   type:'string'},
        {name:'Persona',   type:'string'},
        {name:'Mes',   type:'string'},
        {name:'Anio',   type:'int'},
        {name:'Cargo',   type:'string'},
        {name:'NroDI',   type:'string'},
        {name:'FechaIngreso',   type:'string'},
        {name:'AFP',   type:'string'},
        {name:'CodEsSalud',   type:'string'},
        {name:'CUSPP',   type:'string'},
        {name:'SueldoBasico',   type:'float'},
        {name:'DiasMes',   type:'float'},
        {name:'DiasVacaciones',   type:'float'},
        {name:'Remuneracion',   type:'float'},
        {name:'SubsidioEssalud',   type:'float'},
        {name:'Vacaciones',       type:'float'},
        { name: 'Adelanto', type: 'float' },
        { name: 'AsignacionVacacional', type: 'float' },
        {name:'AsignacionFamiliar',  type:'float'},
        {name:'Gratificacion',   type:'float'},
        {name:'ReintegroSueldo',        type:'float'},
        {name:'BonfExtr',        type:'float'},
        {name:'Bonifi35',        type:'float'},
        {name:'Otros',        type:'float'},
        {name:'TotalIngresos',        type:'float'},
        {name:'FondoSP',        type:'float'},
        {name:'SeguroSP',        type:'float'},
        {name:'ComisionSP',        type:'float'},
        {name:'MontoAFP',        type:'float'},
        {name:'RentaQuinta',        type:'float'},
        {name:'SegVida',        type:'float'},
        {name:'Prestamo',        type:'float'},
        {name:'Descuento',        type:'float'},
        {name:'TotalEgresos',        type:'float'},
        {name:'EsSalud',        type:'float'}
    ]
});

Ext.define('planillaareas',{
    extend: 'Ext.data.Model',
    //idProperty:'',
    fields: [
        {name:'CodigoProy', type:'string'},
        {name:'Proyecto',   type:'string'},
        {name:'Personal',   type:'string'},
        {name:'Cargo',   type:'string'},
        {name:'MesesDia',   type:'float'},
        {name:'FechaIngreso',   type:'string'},
        {name:'VacDias',   type:'float'},
        {name:'CentroCostos',   type:'string'},
        {name:'Coa',   type:'string'},
        {name:'Remuneracion',   type:'float'},
        {name:'SubsidioEssalud',   type:'float'},
        {name:'Adelanto',   type:'float'},
        {name:'Gratificacion',   type:'float'},
        {name:'Otros',   type:'float'},
        {name:'Bonificacion',   type:'float'},
        { name: 'Vacaciones', type: 'float' },
        { name: 'AsignacionVacacional', type: 'float' },
        {name:'AsignacionFamiliar',  type:'float'},
        {name:'NombreCorto',   type:'string'},
        {name:'AFP',        type:'float'},
        {name:'RentaQuinta',        type:'float'},
        {name:'EsSalud',        type:'float'},
        {name:'SegVida',        type:'float'},
        {name:'Descuento',        type:'float'},
        {name:'Prestamo',        type:'float'},
        {name:'Bonifi35',        type:'float'},
        {name:'TotalIngresos',        type:'float'},
        { name: 'TotalEgresos', type: 'float' },
        {name:'Total',        type:'float'}
    ]
});

Ext.define('Personal',{
    extend: 'Ext.data.Model',
    //idProperty:'',
    fields: [
        {name:'IdPersonal', type:'int'},
        {name:'Paterno',   type:'string'},
        {name:'Materno',   type:'string'},
        {name:'Nombres',   type:'string'},
        {name:'ApeNombre',   type:'string'},
        {name:'Direccion',   type:'string'},
        {name:'Sexo',   type:'float'},
        {name:'FechaNacimiento',   type:'string'},
        {name:'Fotocheck',   type:'string'},
        {name:'Tipodi',   type:'float'},
        {name:'Nrodi',   type:'float'},
        {name:'Tiposangre',   type:'float'},
        {name:'Celularpersonal',   type:'float'},
        {name:'Celularins',   type:'float'}
    ]
});

Ext.define('PersonalE',{
    extend: 'Ext.data.Model',
    //idProperty:'',
    fields: [
        {name:'IdPersonal', type:'int'},
        {name:'ApePaterno',   type:'string'},
        {name:'ApeMaterno',   type:'string'},
        {name:'Nombres',   type:'string'},
        {name:'IdNacionalidad',   type:'string'},
        {name:'Nacionalidad',   type:'string'},
        {name:'IdTipoDI',   type:'string'},
        {name:'Descripcion',   type:'string'},
        {name:'LugarNacimiento',   type:'string'},
        {name:'NroDI',   type:'string'},
        {name:'Direccion',   type:'string'},
        {name:'FechaNacimiento',   type:'string'},
        {name:'Sexo',   type:'string'},
        {name:'EstadoCivil',   type:'string'},
        {name:'EsSalud',   type:'string'},
        {name:'LicenciaConducir',   type:'string'},
        {name:'TipoSangre',   type:'string'},
        {name:'Discapacidad',   type:'bool'},
        {name:'Telefonocasa',   type:'string'},
        {name:'Celularpersonal',   type:'string'},
        {name:'Emailpersonal',   type:'string'},
        {name:'TelefenosIns',   type:'string'},
        {name:'Fotocheck',   type:'string'},
        {name:'EmailCoorporativo',   type:'string'},
        {name:'ContactoEmergencia',   type:'string'},
        {name:'TelefonoContacto',   type:'string'},
        {name:'IdBancoHaberes',   type:'string'},
        {name:'BancoHaberes',   type:'string'},
        {name:'CtaHaberes',   type:'string'},
        {name:'IdBancoCTS',   type:'string'},
        {name:'BancoCTS',   type:'string'},
        {name:'CtaCTS',   type:'string'}        
    ]
});

Ext.define('ContratoAdendaPersonal',{
    extend: 'Ext.data.Model',
    //idProperty:'',
    fields: [
        {name:'idcontratoadendapersonal', type:'int'},
        {name:'nro',   type:'string'},
        {name:'IdPersonal',   type:'string'},
        {name:'fechainicio',   type:'string'},
        {name:'fechafin',   type:'string'},
        {name:'fechafinreal',   type:'string'},
        {name:'IdCategoria',   type:'string'},
        {name:'NomCategoriaRRHH',   type:'string'},
        {name:'IdTipoTrabajador',   type:'string'},
        {name:'NomTipoTrabajador',   type:'string'},
        {name:'IdNivelEducativo',   type:'string'},
        {name:'NomNivelEducativo',   type:'string'},
        {name:'IdTipoContrato',   type:'string'},
        {name:'NomTipoContrato',   type:'string'},
        {name:'IdHorario',   type:'string'},
        {name:'NomHorario',   type:'string'},
        {name:'IdGrupoOcupacional',   type:'string'},
        {name:'NomGrupoOcupacional',   type:'string'},
        {name:'IdArea',   type:'string'},
        {name:'NomArea',   type:'string'},
        {name:'IdPosicion',   type:'string'},
        {name:'NomCargo',   type:'string'},
        {name:'IdTipoPagoPlanilla',   type:'string'},
        {name:'NomTipoPagoPlanilla',   type:'string'},
        {name:'IdPeriodicidadIngreso',   type:'string'},
        {name:'NomPeriodicidadIngreso',   type:'string'},
        {name:'idcontrato',   type:'string'},
        {name:'Tipo',   type:'string'},
        { name: 'sueldo', type: 'string' },
        { name: 'IdPeriodoLaboral', type: 'int' },
        { name: 'Seguro', type: 'string' }

//        {name:'BancoHaberes',   type:'string'},
//        {name:'CtaHaberes',   type:'string'},
//        {name:'IdBancoCTS',   type:'string'},
//        {name:'BancoCTS',   type:'string'},
//        {name:'CtaCTS',   type:'string'}        
    ]
});

Ext.define('CCOSTOPORPERSONA',{
    extend: 'Ext.data.Model',
    //idProperty:'',
    fields: [
        {name:'IdCCostoPorPersona', type:'int'},
        {name:'IdCCosto',   type:'int'},
        {name:'porcentaje',   type:'float'},
        {name:'valor',   type:'float'},
        {name:'Estado',   type:'string'},
        {name:'Validado',   type:'string'},
        {name:'idejerciciomes',   type:'int'},
        {name:'IdPersonal',   type:'int'},
        {name:'IdProyecto',   type:'int'},
        {name:'Proyecto',   type:'string'},
        {name:'Ccosto',   type:'string'}
    ]
});

Ext.define('Sexo',{
    extend: 'Ext.data.Model',
    //idProperty:'',
    fields: [
        {name:'IdSexo', type:'string'},
        {name:'NomSexo',   type:'string'},
        {name:'Sexo',   type:'string'}
    ]
});
Ext.define('Seguro',{
    extend: 'Ext.data.Model',
    //idProperty:'',
    fields: [
        {name:'IdSeguro', type:'string'},
        {name:'NomSeguro',   type:'string'},
        {name:'Seguro',   type:'string'}
    ]
});
Ext.define('Estadolrtquinta', {
    extend: 'Ext.data.Model',
    //idProperty:'',
    fields: [
        { name: 'IdEstado', type: 'int' },
        { name: 'NomEstado', type: 'string' },
        { name: 'tipoEstado', type: 'bool' }
    ]
});

Ext.define('TipoPagoLiquidacion', {
    extend: 'Ext.data.Model',
    fields: [
        { name: 'IdTipoPagoLiquidacion', type: 'int' },
        { name: 'NombreTipoPagoLiquidacion', type: 'string' }
    ]
});

Ext.define('DetalleConceptoLiquidacion', {
    extend: 'Ext.data.Model',
    fields: [
        { name: 'IdDetalleConceptoLiquidacion', type: 'int' },
        { name: 'IdPeriodoLaboral', type: 'int' },
        { name: 'Glosa', type: 'string' },
        { name: 'Monto', type: 'float' },
        { name: 'AfectoDeduccion', type: 'bool' }
    ]
});

Ext.define('EstadoCivil',{
    extend: 'Ext.data.Model',
    //idProperty:'',
    fields: [
        {name:'IdEstadoCivil', type:'string'},
        {name:'EstadoCivil',   type:'string'}
    ]
});

Ext.define('Banco',{
    extend: 'Ext.data.Model',
    idProperty:'IdBanco',
    fields: [
        {name:'IdBanco', type:'int'},
        {name:'NomBanco', type:'string'}
    ]
});

Ext.define('BancoCTS',{
    extend: 'Ext.data.Model',
    //idProperty:'',
    fields: [
        {name:'IdBancoCTS', type:'int'},
        {name:'BancoCTS', type:'string'}
    ]
});

Ext.define('BancoHaberes',{
    extend: 'Ext.data.Model',
    //idProperty:'',
    fields: [
        {name:'IdBancoHaberes', type:'int'},
        {name:'BancoHaberes', type:'string'}
    ]
});

Ext.define('SiNo',{
    extend: 'Ext.data.Model',
    //idProperty:'',
    fields: [
        {name:'Id', type:'string'},
        {name:'VF', type:'bool'},
        {name:'Texto',   type:'string'}
    ]
});

Ext.define('PeriodoLaboral',{
    extend: 'Ext.data.Model',
    idProperty:'IdPeriodoLaboral',
    fields: [
        {name:'IdPeriodoLaboral', type:'int'},
        {name:'IdPersonal', type:'int'},
        {name:'FechaInicio',   type:'string'},
        {name:'FechaFin',   type:'string'},
        {name:'NomMotivoFinPeriodo',   type:'string'},
        {name:'IdMotivoFinDePeriodo', type:'int'}
    ]
});

Ext.define('MotivoFinPeriodo',{
    extend: 'Ext.data.Model',
    idProperty:'IdPeriodoLaboral',
    fields: [
        {name:'IdMotivoFinDePeriodo', type:'int'},
        {name:'NomMotivoFinPeriodo', type:'string'},
        {name:'CodSunatMotivoFinPeriodo',   type:'string'}
    ]
});

//Ext.define('FuenteVerificacion',{
//    extend: 'Ext.data.Model',
//    idProperty:'IdPeriodoLaboral',
//    fields: [
//        {name:'IdMotivoFinDePeriodo', type:'int'},
//        {name:'NomMotivoFinPeriodo', type:'int'},
//        {name:'CodSunatMotivoFinPeriodo',   type:'string'}
//    ]
//});

Ext.define('CTServ',{
    extend: 'Ext.data.Model',
    idProperty:'IdCTServ',
    fields: [
        {name:'IdCTServ', type:'int'},
        {name:'idejerciciomes', type:'int'},
        {name:'Proyecto',   type:'string'},
        {name:'IdPeriodoLaboral',   type:'string'},
        {name:'Remuneracion', type:'float'},
        {name:'Personal', type:'string'},
        {name:'DNI', type:'string'},
        {name:'CodCCosto', type:'string'},
        {name:'NomCCosto', type:'string'},
        {name:'FechaIngreso', type:'string'},
        {name:'Gratificacion',   type:'float'},
        {name:'PorcGratificacion', type:'float'},
        {name:'CTS',   type:'float'},
        {name:'Monto',   type:'float'},
        {name:'ProvNovDic', type:'float'},
        {name:'CTSAnio', type:'float'},
        {name:'MontoCTSContable', type:'float'}
    ]
});

Ext.define('CTSProvision',{
    extend: 'Ext.data.Model',
    idProperty:'IdCTSContable',
    fields: [
        {name:'Id', type:'int'}, //IdCTServ
        {name:'IdCTSContable', type:'int'},
        {name:'IdProyecto', type:'int'},
        {name:'Proyecto', type:'string'},
        {name:'Personal', type:'string'},
        {name:'ProvNovDic', type:'float'},
        {name:'MontoCTSContable', type:'float'},
        {name:'CTSAnio', type:'float'},
        {name:'CCosto', type:'string'},
        {name:'IdCCosto', type:'int'}
    ]
});

Ext.define('CTSProvisionD',{
    extend: 'Ext.data.Model',
    idProperty:'IdCTSContable',
    fields: [
        {name:'IdCTSContable', type:'int'},
        {name:'IdProyecto', type:'int'},
        {name:'Proyecto', type:'string'},
        {name:'IdCCosto', type:'int'},
        {name:'CCosto', type:'string'},
        {name:'Tipo', type:'string'},
        {name:'Monto', type:'float'},
    ]
});

Ext.define('CTSContable',{
    extend: 'Ext.data.Model',
    idProperty:'IdCTSContable',
    fields: [
        {name:'IdCTSContable', type:'int'},
        {name:'IdCTServ', type:'int'},
        {name:'Monto',   type:'float'},
        {name:'IdCCosto',   type:'int'},
        {name:'CCosto',   type:'string'},
        {name:'IdProyecto',   type:'int'},
        {name:'Proyecto',   type:'string'},
        {name:'FechaPago',   type:'string'}   
    ]
});

/*CONTABILIDAD*/
Ext.define('Ejercicio',{
    extend: 'Ext.data.Model',
    idProperty:'IdEjercicio',
    fields: [
        {name:'IdEjercicio', type:'int'},
        {name:'idejerciciomes', type:'int'},
        {name:'mes',   type:'string'},
        {name:'vigente',   type:'string'},
        {name:'Anio',   type:'string'},
        {name:'IdTipoTrabajador', type:'int'},
        {name:'NomTipoTrabajador',   type:'string'}
    ]
});

Ext.define('EjercicioMes',{
    extend: 'Ext.data.Model',
    idProperty:'idejerciciomes',
    fields: [
        {name:'idejerciciomes', type:'int'},
        {name:'IdEjercicio', type:'int'},
        {name:'mes',   type:'string'},
        {name:'vigente',   type:'string'},
        {name:'Anio',   type:'string'}
    ]
});

Ext.define('VinculoFamiliar', {
    extend: 'Ext.data.Model',
    idProperty: 'IdVinculo',
    fields: [
        { name: 'IdVinculo', type: 'int' },
        { name: 'Codigo', type: 'string' },
        { name: 'NomVinculoFamiliar', type: 'string' }
    ]
});

Ext.define('AcreditaVinculoFamiliar', {
    extend: 'Ext.data.Model',
    idProperty: 'idacreditavinculofamiliar',
    fields: [
        { name: 'idacreditavinculofamiliar', type: 'int' },
        { name: 'Codigo', type: 'string' },
        { name: 'NomAcreditaVinculofamiliar', type: 'string' }
    ]
});

Ext.define('EstadoEsSalud', {
    extend: 'Ext.data.Model',
    idProperty: 'IdEstadoEsSalud',
    fields: [
        { name: 'IdEstadoEsSalud', type: 'int' },
        { name: 'NomEstadoEsSalud', type: 'string' },
        { name: 'CodEstadoEsSalud', type: 'string' }
    ]
});

Ext.define('DerechoHabiente', {
    extend: 'Ext.data.Model',
    idProperty: 'IdDerechoHabiente',
    fields: [
        { name: 'IdDerechoHabiente', type: 'int' },
        { name: 'IdPersonal', type: 'int' },
        { name: 'NomVinculoFamiliar', type: 'string' },
        { name: 'IdVinculo', type: 'int' },
        { name: 'Nombre', type: 'string' },
        { name: 'ApePaterno', type: 'string' },
        { name: 'ApeMaterno', type: 'string' },
        { name: 'EstadoCivil', type: 'string' },
        { name: 'FechaNacimiento', type: 'string' },
        { name: 'Discapacidad', type: 'bool' },
        { name: 'Estudiando', type: 'bool' },
        { name: 'IdEstadoEsSalud', type: 'int' },
        { name: 'Estado', type: 'int' },
        { name: 'FechaConvivencia', type: 'string' },
        { name: 'IdNacionalidad', type: 'int' },
        { name: 'Nacionalidad', type: 'string' },
        { name: 'IdTipoDI', type: 'int' },
        { name: 'Descripcion', type: 'string' },
        { name: 'NroDI', type: 'string' },
        { name: 'idacreditavinculofamiliar', type: 'int' },
        { name: 'NomAcreditaVinculofamiliar', type: 'string' },
        { name: 'FechaAlta', type: 'string' },
        { name: 'idbajaderechohabiente', type: 'int' },
        { name: 'nrodocumento', type: 'string' },
        { name: 'FechaAlta', type: 'string' },
        { name: 'FechaBaja', type: 'string' }
    ]
});
Ext.define('CostoSistemadePensiones', {
    extend: 'Ext.data.Model',
    idProperty: 'idcostosistemadepensiones',
    fields: [
        { name: 'idcostosistemadepensiones', type: 'int' },
        { name: 'IdSistemaPensiones', type: 'int' },
        { name: 'idejerciciomes', type: 'int' },
        { name: 'fondo', type: 'float' },
        { name: 'comision', type: 'float' },
        { name: 'seguro', type: 'float' },
        { name: 'topeseguro', type: 'float' },
        { name: 'editable', type: 'bool' },
        { name: 'comisionmixta', type: 'float' }
    ]
});
Ext.define('AfiliacionSP', {
    extend: 'Ext.data.Model',
    idProperty: 'IdAfiliacionSP',
    fields: [
        { name: 'IdAfiliacionSP', type: 'int' },
        { name: 'IdPersonal', type: 'int' },
        { name: 'IdSistemaPensiones', type: 'int' },
        { name: 'FechaAfiliacion', type: 'date' },
        { name: 'CUSPP', type: 'string' },
        { name: 'Estado', type: 'bool' },
        { name: 'IdTipoAfiliacion', type: 'int' }
    ]
})
Ext.define('Certificadorq', {
    extend: 'Ext.data.Model',
    idProperty: 'id',
    fields: [
        { name: 'idcertificadorq', type: 'int' },
        { name: 'IdPersonal', type: 'int' },
        { name: 'fechainicio', type: 'date' },
        { name: 'fechafin', type: 'date' },
        { name: 'ingresos', type: 'float' },
        { name: 'rqpagadas', type: 'float' },
        { name: 'estado', type: 'bool' },
        { name: 'IdEjercicio', type: 'int' }
    ]
});